Grist MCP Server

Grist is a flexible spreadsheet-database that powers everything from CRMs to project trackers to inventory systems. The Grist MCP server lets agents work across your team sites and documents.

What it can do

• Read: list orgs, workspaces, docs, tables, columns, records.
• Query: run SQL-style queries across the tables in a doc.
• Write: add, update, remove records.
• Schema: create or remove tables and columns.
• Create new documents from a description.

Connect

• MCP URL: https://docs.getgrist.com/api/mcp
• Transport: Streamable HTTP
• Authentication: OAuth 2.0 (Dynamic Client Registration / CIMD)

The same URL works for every user and every team site, the OAuth bearer token identifies you.

Documentation

• Setup guide and tool list: https://support.getgrist.com/mcp
• Grist website: https://www.getgrist.com
• Privacy policy: https://www.getgrist.com/privacy/

Quick example config (Claude Desktop, ChatGPT, any HTTP MCP client)

{
  "mcpServers": {
    "grist": {
      "type": "http",
      "url": "https://docs.getgrist.com/api/mcp"
    }
  }
}